﻿CREATE TABLE [util].[ScheduleExceptions] (
    [DateKey]     SMALLDATETIME  NOT NULL,
    [TypeId]      INT            NOT NULL,
    [Description] NVARCHAR (512) NOT NULL,
    CONSTRAINT [PK_UtilScheduleExceptions_DateKeyTypeId] PRIMARY KEY CLUSTERED ([DateKey] ASC, [TypeId] ASC),
    CONSTRAINT [FK_UtilScheduleExceptionTypes] FOREIGN KEY ([TypeId]) REFERENCES [util].[ScheduleExceptionTypes] ([Id])
);

